---------------------------------------------------------------------------------------------------
IF (SELECT OBJECT_ID('CaseManagement.GetAllTypesOfKinship')) IS NOT NULL
BEGIN
	DROP PROCEDURE CaseManagement.GetAllTypesOfKinship 
END
---------------------------------------------------------------------------------------------------

GO
CREATE PROCEDURE CaseManagement.GetAllTypesOfKinship

AS 

---------------------------------------------------------------------------------------------------
--						Liberty
---------------------------------------------------------------------------------------------------
--  Stored Procedure :: GetAllTypesOfKinship
--                                                                            
---------------------------------------------------------------------------------------------------

SET NOCOUNT ON 

SELECT 	
	OID,
	Version,
	Description,
	DisplayOrder,
	Active
FROM TypesOfKinship
WHERE Active = 1        
ORDER BY DisplayOrder    

GO

---------------------------------------------------------------------------------------------------
-- Assign appropriate permissions
---------------------------------------------------------------------------------------------------
GRANT EXECUTE ON CaseManagement.GetAllTypesOfKinship TO [Liberty_Users]
GO

